<?php  if (!defined('BASEPATH')) exit('No direct script access allowed');

/**
 * CodeIgniter
 *
 * An open source application development framework for PHP 4.3.2 or newer
 *
 * @package		CodeIgniter
 * @author		ExpressionEngine Dev Team
 * @copyright	Copyright (c) 2008, EllisLab, Inc.
 * @license		http://codeigniter.com/user_guide/license.html
 * @link		http://codeigniter.com
 * @since		Version 1.0
 * @filesource
 */
// ------------------------------------------------------------------------
/**
 * Database Result Class
 *
 * This is the platform-independent result class.
 * This class will not be called directly. Rather, the adapter
 * class for the specific database will extend and instantiate it.
 *
 * @category	Database
 * @author		ExpressionEngine Dev Team
 * @link		http://codeigniter.com/user_guide/database/
 */
class CI_DB_result {
    
    var $conn_id = NULL;
    var $result_id = NULL;
    var $result_array	= array();
    var $result_object	= array();
    var $current_row = 0;
    var $num_rows = 0;
    var $row_data = NULL;

    /**
     * Query result.  Acts as a wrapper function for the following functions.
     *
     * @access	public
     * @param	string	can be "object" or "array"
     * @return	mixed	either a result object or array
     */
    function result($type = 'object') {
        return ($type == 'object') ? $this->result_object() : $this->result_array();
    }

// --------------------------------------------------------------------
    /**
     * Query result.  "object" version.
     *
     * @access	public
     * @return	object
     */
    function result_object() {
        if (count($this->result_object) > 0) {
            return $this->result_object;
        }

        // In the event that query caching is on the result_id variable
        // will return FALSE since there isn't a valid SQL resource so
        // we'll simply return an empty array.
        if ($this->result_id === FALSE OR $this->num_rows() == 0) {
            return array();
        }

        $this->_data_seek(0);
        while ($row = $this->_fetch_object()) {
            $this->result_object[] = $row;
        }

        return $this->result_object;
    }

// --------------------------------------------------------------------
    /**
     * Query result.  "array" version.
     *
     * @access	public
     * @return	array
     */
    function result_array() {
        if (count($this->result_array) > 0) {
            return $this->result_array;
        }

        // In the event that query caching is on the result_id variable
        // will return FALSE since there isn't a valid SQL resource so
        // we'll simply return an empty array.
        if ($this->result_id === FALSE OR $this->num_rows() == 0) {
            return array();
        }

        $this->_data_seek(0);
        while ($row = $this->_fetch_assoc()) {
            $this->result_array[] = $row;
        }

        return $this->result_array;
    }

// --------------------------------------------------------------------
    /**
     * Query result.  Acts as a wrapper function for the following functions.
     *
     * @access	public
     * @param	string
     * @param	string	can be "object" or "array"
     * @return	mixed	either a result object or array
     */
    function row($n = 0, $type = 'object') {
        if (!is_numeric($n)) {
            // We cache the row data for subsequent uses
            if (!is_array($this->row_data)) {
                $this->row_data = $this->row_array(0);
            }

            // array_key_exists() instead of isset() to allow for MySQL NULL values
            if (array_key_exists($n, $this->row_data)) {
                return $this->row_data[$n];
            }
            // reset the $n variable if the result was not achieved
            $n = 0;
        }

        return ($type == 'object') ? $this->row_object($n) : $this->row_array($n);
    }

// --------------------------------------------------------------------
    /**
     * Assigns an item into a particular column slot
     *
     * @access	public
     * @return	object
     */
    function set_row($key, $value = NULL) {
        // We cache the row data for subsequent uses
        if (!is_array($this->row_data)) {
            $this->row_data = $this->row_array(0);
        }

        if (is_array($key)) {
            foreach ($key as $k => $v) {
                $this->row_data[$k] = $v;
            }

            return;
        }

        if ($key != '' AND !is_null($value)) {
            $this->row_data[$key] = $value;
        }
    }

// --------------------------------------------------------------------
    /**
     * Returns a single result row - object version
     *
     * @access	public
     * @return	object
     */
    function row_object($n = 0) {
        $result = $this->result_object();

        if (count($result) == 0) {
            return $result;
        }

        if ($n != $this->current_row AND isset($result[$n])) {
            $this->current_row = $n;
        }

        return $result[$this->current_row];
    }

// --------------------------------------------------------------------
    /**
     * Returns a single result row - array version
     *
     * @access	public
     * @return	array
     */
    function row_array($n = 0) {
        $result = $this->result_array();

        if (count($result) == 0) {
            return $result;
        }

        if ($n != $this->current_row AND isset($result[$n])) {
            $this->current_row = $n;
        }

        return $result[$this->current_row];
    }

// --------------------------------------------------------------------
    /**
     * Returns the "first" row
     *
     * @access	public
     * @return	object
     */
    function first_row($type = 'object') {
        $result = $this->result($type);

        if (count($result) == 0) {
            return $result;
        }
        return $result[0];
    }

// --------------------------------------------------------------------
    /**
     * Returns the "last" row
     *
     * @access	public
     * @return	object
     */
    function last_row($type = 'object') {
        $result = $this->result($type);

        if (count($result) == 0) {
            return $result;
        }
        return $result[count($result) - 1];
    }

// --------------------------------------------------------------------
    /**
     * Returns the "next" row
     *
     * @access	public
     * @return	object
     */
    function next_row($type = 'object') {
        $result = $this->result($type);

        if (count($result) == 0) {
            return $result;
        }

        if (isset($result[$this->current_row + 1])) {
            ++$this->current_row;
        }

        return $result[$this->current_row];
    }

// --------------------------------------------------------------------
    /**
     * Returns the "previous" row
     *
     * @access	public
     * @return	object
     */
    function previous_row($type = 'object') {
        $result = $this->result($type);

        if (count($result) == 0) {
            return $result;
        }

        if (isset($result[$this->current_row - 1])) {
            --$this->current_row;
        }
        return $result[$this->current_row];
    }

// --------------------------------------------------------------------
    /**
     * The following functions are normally overloaded by the identically named
     * methods in the platform-specific driver -- except when query caching
     * is used.  When caching is enabled we do not load the other driver.
     * These functions are primarily here to prevent undefined function errors
     * when a cached result object is in use.  They are not otherwise fully
     * operational due to the unavailability of the database resource IDs with
     * cached results.
     */
    function num_rows() {
        return $this->num_rows;

    }

    function num_fields() {
        return 0;

    }

    function list_fields() {
        return array();

    }

    function field_data() {
        return array();

    }

    function free_result() {
        return TRUE;

    }

    function _data_seek() {
        return TRUE;

    }

    function _fetch_assoc() {
        return array();

    }

    function _fetch_object() {
        return array();

    }
}

// END DB_result class

/* End of file DB_result.php */
/* Location: ./system/database/DB_result.php */